package com.tencent.wxcloudrun.mapper;

import com.tencent.wxcloudrun.dto.GoodsPrice;
import com.tencent.wxcloudrun.dto.Skulist;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.Map;

/**
 * @Entity com.tencent.wxcloudrun.dto.Skulist
 */
@Mapper
public interface SkulistMapper {

    GoodsPrice getGoodsPrice(Integer goodsId, String propertyChildIds);

    @Select("select * from skuList where goodsId=#{goodid} and propertychildnames=#{propertychildNames}")
    GoodsPrice getGoodsPrice2(Integer goodid, String propertychildNames);

    @Select("select pingtuanPrice ,originalPrice,minPrice,minScore from goods where  id=#{goodid}")
    Map<String,Integer> getGoodsPrices(Integer goodid);
}




